Transposing similar records to column

[Venky_1992]

Hi I am having trouble to convert similar records in column A  having values in column B to column having values from column B

check the screenshots

[ed_hayter · Accepted solution]

Hi @Venky_1992 , i have attached a flow that gets to your output.

Up to the union is just making sure i dont lose the data that was currently being brought in as a field header in the excel flow.

This logic relies on the fact that every entry has an access row and that it is the last one for each record. I can then make a recordID that allows us to cross-tab.

Ultimately, a solution to this is usually a case of identifying a feature in the data that is consistent and allows you to determine when a new record starts.