Multiple Tables in a single Excel worksheet, create Tables based on a criteria

[bobbybalan]

Hello, I have the below dataset. How can I create two separate Tables for each Category (Cat A and Cat B) in a single worksheet? The columns in each Table will be Month 1, 2 and rows will be Item1, Item2, Item 3. I am attaching the output here. Thanks so much in advance!

Category  Month    Items    Dollar

Cat A        1            Item 1    100
Cat A        1            Item 2    200
Cat A        1            Item 3    300
Cat A        2            Item 1      10
Cat A        2            Item 2      20
Cat A        2            Item 3      30
Cat B        1            Item 1      60
Cat B        1            Item 2      70
Cat B        1            Item 3      80
Cat B        2            Item 1        1
Cat B        2            Item 2        2
Cat B        2            Item 3        3

[drew9]

Hi @bobbybalan ,

I built a macro which will accommodate more than two categories. The output is a little different than what you asked for but this works better anyway.

I hope this helps!