G
Guest
I have multiple account numbers with multiple codes and need to transpose the
data.
Example data
12 a
12 b
13 a
14 a
14 b
14 c
I would like the data to look like
12 a b
13 a
14 a b c
This can be completed in Excel by adding a count to the number and using it
as a column in the crosstab query. I can not perform this in Excel due to
the row limitation.
Any help would be appreciated.
Thank you
data.
Example data
12 a
12 b
13 a
14 a
14 b
14 c
I would like the data to look like
12 a b
13 a
14 a b c
This can be completed in Excel by adding a count to the number and using it
as a column in the crosstab query. I can not perform this in Excel due to
the row limitation.
Any help would be appreciated.
Thank you