Hello UiPath and data table manipulation gurus,
I need to realign some data in a Excel (please see s/c below).
Currently, I loop through column C (“Number”) and determine whether it is a 6 digit value starting with H. Then = nothing; else = (where I’m stuck) I need to search horizontally on that row to find where the 6 digit H* value is, find its location, transfer it and all related data (to the right) starting in col C. . .
My initial thoughts were to just make nested if statements (yikes!) to search col D, E, F, G for the same “6 digit, H*” criteria and perform hotkeys like “[d(ctrl)][d(shift)][k(right)][u(shift)]x[u(ctrl)]” to cut and paste in col C. . . I’m assuming there is a much smarter way to do this with more concise code or an invoke method or something.
I’d greatly appreciate any thoughts on how best to approach this!
shiftDataRow.zip (33.1 KB)