
Hello,
I'm new to Power automate, please help to format the data in columns A, B, C to a different columns F,G,H,I,J. In the attached excel the source data is in A, B, C columns and formatted data is in columns F,G,H,I,J. Basically the final formatted data could be in same work sheet or in new excel or csv file.
F column => Title: concatenation of user input + A1 and A11 cells.
G column => Step: Step numbers.
H column => Action: concatenation of A12 + B12 and then A12 + B13. Here A12 is a merged cell.
I column => Expected Results: All data from C column.
J column => Description: concatenation of A3 to A10. The A3 to A10 are merged cells. Sometimes the cell range could be A11 or A12 or A9 based on business data entered.