Move all data to one column or Subtotal Help

[rocklobster]

Is there a way (other than c&p) to move all data into one column.

Here is what i have.

my data comes across in tab delimited, when i open it in excel it is going across the sheet.

(1)(widget)(2)(things)(3)(brackets) etc... () =a cell
(2)(brackets)(3)(widgets)

I need

(1)(widget)
(2)(things)
(3)(brackets)
(2)(brackets)
(3)(widgets)

I have 16 pairs of columns wide and the length of the columns varies each time. Right now i cut each column and paste it under A and B. 16 times

I then subtotal to get how many widgets, things and brackets.

So 2 things, is there a way either with macros or some other command to move the data or is there a way to subtotal this information with out having to move the data in the first place.

I hope that this make some sense???

thank in advance

Rock Lobster

 

[rocklobster]

<bump>

 

[Domenic]

Let's assume that A2:F10 contains the data, let H2:H4 contain widgets, things, and brackets, then try...

I2, copied down:

=SUMIF($B$2:$F$10,H2,$A$2:$E$10)

Hope this helps!