Changing Format of Sheet

**liamfrancis2013** · 05-19-2016, 05:09 AM

Wanting to change the look of my page.

Here's how it currently looks:
1.png

Here's how i want it to look:
2.png

This is only a quick example sheet i made however, the real sheet contains considerably more (1000's) of rows of data. So i want some clever way to change the look of my sheet

Thanks,
Liam

**shukla.ankur281190** · 05-19-2016, 05:14 AM

Can you upload excel workbook ??

**liamfrancis2013** · 05-19-2016, 05:36 AM

For some reason i can't upload it from my work PC, here's a dropbox link https://www.dropbox.com/s/0skqf72bnm...ints.xlsx?dl=0

Thanks,
Liam

**shukla.ankur281190** · 05-19-2016, 06:17 AM

oK

try

A3=IFERROR(INDEX('Raw Data'!$A$2:$A$33,MATCH(0,INDEX(COUNTIF('Ideal (2)'!$A$2:A2,'Raw Data'!$A$2:$A$33),),0)),"") and drag down.

B3=INDEX('Raw Data'!$A$1:$F$33,MATCH('Ideal (2)'!$A3,'Raw Data'!$A$1:$A$33,),MATCH('Ideal (2)'!B$2,'Raw Data'!$A$1:$F$1,0)) and drag to till D column and down.

E3=INDEX('Raw Data'!$E$1:$E$33,MATCH('Ideal (2)'!$A3&RIGHT('Ideal (2)'!E$2,1),INDEX('Raw Data'!$A$1:$A$33&RIGHT('Raw Data'!$F$1:$F$33,1),),0)) and drag towards the cell and down.

Check the attached file.