Displaying Data from rows in fewer Colomns

[McLeo]

Hello everybody,


I need to change the structure of a table from this one

A1 B1 1 2 3

A2 B2 1 2 3



to the following structure:

A1 1 2 3

A1 1 2 3

A1 1 2 3



A2 1 2 3
A2 1 2 3
...



I thank you in advance for any help!
Kind regeards
Leo

[NoSparks]

What you're saying and showing is rather vague.

What's the logic to this ?
Why duplicates?
Why 3 rows for A1 and 2 for A2 ?
Why blank rows between the A1's and not the A2's ?
How many columns are actually in each table ?
Are these tables true Excel tables or standard ranges ?
What are the headers ?
Where on what sheet does the original data exist ?
Where are you wanting the results to be placed ?

How about attaching a workbook with sample data showing what you are really starting with and what you really want to end up with.

[Pecoflyer]

Gee NoS, that's a lot of question marks !

[ArviLaanemets]

Is this on once or permanent? When former, then Copy and PasteSpecial>Transpose (into location not intersecting with old data).

Having blank rows in tables is BAD (and EVIL)!

[NoSparks]

Originally Posted by Pecoflyer

Gee NoS, that's a lot of question marks !

You can't get from one place to another without knowing where you're going.

It's now up to the OP.