I want to convert below formatted Input table into output table. I tried Cross Tabs & Arrange blocks but had a hard time. Can anyone help me out with this?
I need to arrange everything in single concatenated row.
Input: | ||||||
Branch Name | Region | Location | No | No2 | Contact No | Person detais |
Baroda | Gujarat | 24 Radha Park | shukla | Williams | ||
opp Mandir | 12221 | 833 | 604-000-3860 | 1234 | ||
Ph 25558888 | Toll free: 67 | |||||
Mumbai | Maharastra | Nanadanvan Society | rajan shukla | Sweta | ||
Subbranch | Parle, 30880 | 15600 | 171 | NoL 676769 | 97986869 | |
hioio | ||||||
Ph: 78760977 | Fax: 23889823 | rr |
Output:
Branch Name | Region | Location | No | No2 | Contact No | Person detais |
Baroda | Gujarat | 24 Radha Parkopp MandirPh 25558888 | 12221 | 833 | shukla604-000-3860Toll free: 67 | Williams1234 |
MumbaiSubbranch | Maharastra | Nanadanvan SocietyParle, 30880 hioioPh: 78760977 | 15600 | 171 | rajan shuklaNoL 676769Fax: 23889823 | Sweta97986869rr |
Solved! Go to Solution.
Hey @gopi1987
The best way to approach this is to identify the start of a new line, for example I used if region is populated but you can use whatever makes sense for your data.
Once this has been identified, you can add an ID which groups the records and then makes transposing/crosstabbing the data much easier.
Example attached
Thanks Ponraj..That helps
Thanks @LordNeilLord... that's helpful :)