Stacking columns

[asim2292]

Hey everyone! this is my first of many questions i'm sure to have, excited to be on this forum to better my knowledge of excel.

I have a question about stacking data, i have a data set in which 3 columns need to be in the same column to count them. I have a manual process of copying each column and stacking them on top of each other but this is somewhat time-consuming and has the possibility for huge error. any tips on data stacking as far as functions or macros? Thanks in advance!

below is an example

A B C D E

1 x W Z P 4

2 x 4

3 x W Z

Changed to

A B C
1 x w 4

2 x z 4

3 x p 4

4 x w 4

5 x z 4

 

[StephenCrump]

Welcome to the Forum!

Sorry, it's not clear to me what you mean by stacking?

Can you step us through how your data set changes from:

1xwzP4
2x4
3xwz

to:

1xw4
2xz4
3xp4
4xw4
5xz4

Also, what exactly are you counting? For the first dataset you've posted, what results do you expect to see when you do the counting?

 

[My Aswer Is This]

I don't understand how stacking can turn this:
below is an example

A B C D E

1 x W Z P 4

2 x 4

3 x W Z


Into this???

Changed to

A B C
1 x w 4

2 x z 4

3 x p 4

4 x w 4

5 x z 4

Where is the "5" for example in the original text ?