Good afternoon everyone,
I currently have an excel spreadsheet that looks like the following. Basically one record in multiple rows that I need to custom merge:
I would like to merge it to look like this
Basically if you notice, certain columns like ID300 column , I would simply want to pipe delimit all of the results into one cell. On the other hand, certain other type of columns like ns1:Type1 I would like to split into N number of columns depending on how many value(s) it has (for example this one has 2 non-empty values so we would add ns1:Type1 (Soc) and ns1:Type1(ID), and the value from each of the columns would be from ns1:Num1231.
For example ns1:Type1 (Soc) would have 123654 and ns1:Type1 ID would have 954785. How can I achieve this complex merging?