Formatting Data

[robbied81]

Hi,

Can someone help me. I'm trying to format the data in a specific way. The example is attached.

Any help will be greatly appreciated.

Thanks

Rob

[TMS]

That's not really formatting, that's restructuring the data.

It looks as though a Pivot Table would go a long way to giving you what you want with little effort.

Regards, TMS

[robbied81]

Hi TMS

I tried the pivot table. However, I can't seem to join columns A+B today. I'm able to get the column C and column A, but I want it to be A and B.

Is that possible?

Thanks

Rob

[Sam Capricci]

is this something like what would work for you?

[robbied81]

Hi Sambo

That is what I'm after. Thank you both for your help.

Thanks

Rob

[Sam Capricci]

Thanks for the rep bump but I only piggybacked on TMS's recommendation so don't forget to thank him if you haven't.
and don't forget to mark the post as solved if you haven't already.

[TMS]

Bit of a kludge. Helper column (C) joining A and B and then using that.

See the attached updated example.

Can't help feeling there's a better way.

Regards, TMS