May 18 2022 06:10 AM
Hello, I will try to be clear sorry if am not
Have I data that is structure like such:
COLUMN A B
1:phone | customer info
2: email | custumer info
3: phone | custumer info
4: email | custumer info
I would like to know how I can restructure it as follow
email phone
----------------
info info
info info
Thanks
May 18 2022 06:35 AM
Power Query could work:
Script is
let
Source = Excel.CurrentWorkbook(){[Name="data"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"Column1"}, {{"Info", each _[Column2]}}),
Custom1 = Table.FromColumns(#"Grouped Rows"[Info], #"Grouped Rows"[Column1])
in
Custom1
May 18 2022 07:12 AM
A formula solution. Please see attached workbook.
May 18 2022 07:32 AM
May 18 2022 02:02 PM
If for any Excel here
in G2
=IFERROR( INDEX( $B:$B, AGGREGATE(15,6,1/($A:$A=G$1)*( ROW($A:$A) - ROW($A$1) +1 ), ROW()-ROW($G$1) ) ), "")
and drag it to the right and down till cells with empty text appear. The only it's much better to take some range instead of entire columns (or table or dynamic range).