formatting issue

K2Rider57 · Dec 17, 2004

I'm new to the group and am having a bit of a reformatting issue. I have a long list of data that is grouped like this

A 1
B 10
C 16
D New
E Y

A 11
B 6
C 31
D Old
E Y

....
and I want it to look like this
A B C D E
1 10 16 New Y
11 6 31 Old Y

...

and the list is long so I can't just do it by hand

thanks for the help
K2Rider57

FinancialAnalystKid · Dec 17, 2004

Two things...

You'll need to save this Macro to the workbook...

http://www.vbaexpress.com/kb/getarticle.php?kb_id=8

then you need to set it up with the ABCDE at the top and numbers down the left side as to how many lists you have.

Here's a sample:

Book13

A

B

C

D

E

F

G

H

I

1

NAME

DATA

A

B

C

D

E

2

A

1

3

B

10

2

4

C

16

3

5

D

New

4

6

E

Y

7

8

A

11

9

B

6

10

C

31

11

D

Old

12

E

Y

13

14

A

12

15

B

5

16

C

18

17

D

Old

18

E

N

19

20

A

5

21

B

3

22

C

2

23

D

New

24

E

Y

Sheet1

Replace the range in formulas as desired. I renamed the formula "vlookupnthT" but you can just use what's on the code which is "vlookupnth".

Good luck.

K2Rider57 · Dec 17, 2004

Thanks a lot.. solution works great.

K2Rider57

formatting issue

K2Rider57

New Member

Excel Facts

FinancialAnalystKid

Well-known Member

K2Rider57

New Member

Similar threads

Forum statistics

Share this page

formatting issue

K2Rider57

New Member

Excel Facts

FinancialAnalystKid

Well-known Member

K2Rider57

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock