Combine Data From Two Rows Into One Row

[jdkuehne]

I'm not really sure what the correct name is for what I want to do, so here's a description.

I have an Excel sheet where column A has, in some cases, the same value, but column B is always different. I want to move the secondary column B values to column C, Column D, etc. so the values are all on the first row of the value in column A. Like this...

This data set...

A	B	C	D	E
widget1	1-1
widget1	1-2
widget1	1-3
widget2	2-1
widget2	2-2
widget3	3-1
widget4	4-1
widget4	4-2
widget4	4-3

<tbody>
</tbody>

should be converted to this.

A	B	C	D	E
widget1	1-1	1-2	1-3
widget2	2-1	2-2
widget3	3-1
widget4	4-1	4-2	4-3

<tbody>
</tbody>

Is this possible?

 

[jtakw]

Duplicate post of: https://www.mrexcel.com/forum/excel-questions/1076849-merge-data-two-lines-into-one.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.