Data arrangement

**akumagaavese** · 03-13-2015, 02:23 PM

Dear Friends. I have this data in sheet1 and I want to rearrange as it appears in sheet. Thank you for your help

**mcmahobt** · 03-13-2015, 02:32 PM

Paste into C2 and enter as an array with Ctrl+Shift+Enter:

Please Login or Register  to view this content.

**akumagaavese** · 03-13-2015, 02:56 PM

Dear mcmahobt. That was a great help. I don't know, when I drag it down, it skip some years. it only copy 83, 86 and 91.

**akumagaavese** · 03-13-2015, 02:59 PM

Dear mcmahobt. it worked perfect. thank you. I really appreciate

**mcmahobt** · 03-13-2015, 02:59 PM

Those are the only three years that are in your Original_data worksheet in the example you provided.

Re: Data arrangement