Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 159
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
I have two columns of data where column A has items but then column B has multiple ways the item in column A is referenced. How can I arrange the data that is now in different rows to show horizontally so I can have it in a table?
Column A. Column B
12345. Apple
12345. Pear
5678. Red
5678. Blue
So I want to transform this data to show like this:
Column A. column B. column C.
12345. Apple. Pear
5678. Red. Blue
Column A. Column B
12345. Apple
12345. Pear
5678. Red
5678. Blue
So I want to transform this data to show like this:
Column A. column B. column C.
12345. Apple. Pear
5678. Red. Blue