I'm trying to group rows of random numbers into groups of rows

[subvtech]

Hello everyone,

It's my first time posting here. My knowledge in Excel is ever improving but is not as complex as some of the threads I've read here. So I think I'm in the right place. I have a sheet that looks like this:

KEY1	58	31	58	29	31
KEY2	18	12	18
KEY3	70	71	70	70	70

What I am trying to do is to group the numbers together so that there is one row per group of numbers. The output should be like this:

KEY1	58	58
KEY1	31	31
KEY1	29
KEY2	18	18
KEY2	12
KEY3	70	70	70	70
KEY3	71

Don't have the slightest idea how to repeat the first column per group.

Not sure what would be my approach here.

Thanks

SVT

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Splitting Row by values into multiple rows
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.