excel - Trying to normalise data (I think!) -
i hope here can help me struggling with! trying head around macros/vba's etc little success! looking normalise info (i think!). have number of rows, want multiply 5, each given prefix column heading. wish add together info on new work book pages, new page each term in column b. wish number each row consecutively, starting 1 on each page. have tried show trying accomplish below, help appreciated!
from this:
+-----------+------------+--------------------+---+---+---+---+---+ | town | county | description | | b | c | d | e | +-----------+------------+--------------------+---+---+---+---+---+ | langholm | dumgal | 2150 | | | | | | | canonbie | dumgal | 346 | | | | | | | lockerbie | dumgal | 5489 | | | | | | | dumfries | dumgal | 9005 | | | | | | | hawick | borders | 4003 | | | | | | | kelso | borders | 3470 | | | | | | +-----------+------------+--------------------+---+---+---+---+---+
to this:
workbook page 1:
+----+---+-----------+--------+------+ | 1 | | langholm | dumgal | 2150 | | 2 | b | langholm | dumgal | 2150 | | 3 | c | langholm | dumgal | 2150 | | 4 | d | langholm | dumgal | 2150 | | 5 | e | langholm | dumgal | 2150 | | 6 | | canonbie | dumgal | 346 | | 7 | b | canonbie | dumgal | 346 | | 8 | c | canonbie | dumgal | 346 | | 9 | d | canonbie | dumgal | 346 | | 10 | e | canonbie | dumgal | 346 | +----+---+-----------+--------+------+
workbook page 2:
+---+---+--------+---------+------+ | 1 | | hawick | borders | 4003 | | 2 | b | hawick | borders | 4003 | | 3 | c | hawick | borders | 4003 | | 4 | d | hawick | borders | 4003 | | 5 | e | hawick | borders | 4003 | +---+---+--------+---------+------+
excel excel-vba
No comments:
Post a Comment