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
Solved! Go to 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.