Turning a Vertical Table into a Horizontal one

**Rob8489** · 06-11-2013, 03:51 AM

Hi All

Im really struggling with something I know is relatively simple but im missing something in my H or Vlookups

Please see image link and attachment regarding what Im trying to do

Any help would be awesome

http://i.imgur.com/mpdKzg0.png

**:) Sixthsense :)** · 06-11-2013, 04:01 AM

In E2 Cell – Array Formula – Requires CTRL+SHIFT+ENTER

Formula:

Please Login or Register  to view this content.

Drag it down and right…

**akhileshgs** · 06-11-2013, 04:01 AM

Please have a look at this

**Ghozi Alkatiri** · 06-11-2013, 05:05 AM

formula header column at E1 (array formula)
{=IFERROR(INDEX($A$2:$A$85;MATCH(;COUNTIF($D1:D1;$A$2:$A$85);0));"")}
drag to right

formula to fill table start at E2 (array formula)
{=IFERROR(INDEX($B$2:$B$85;SMALL(IF($A$2:$A$85=E$1;ROW($B$2:$B$85)-ROW($B$1));ROW(1:1)));"")}
drag to right and down

**Marcol** · 06-11-2013, 06:35 AM

Another way is to use dynamic Names to avoid CSE arrays, names are treated as arrays automatically.

Name:= "Department"
Refers to:=

Formula:

Please Login or Register  to view this content.

Name:= "Position"
Refers to:=

Formula:

Please Login or Register  to view this content.

Then for headers
In E1 Drag across as required.

Formula:

Please Login or Register  to view this content.

In E2, Drag Across and down

Formula:

Please Login or Register  to view this content.

**Rob8489** · 06-11-2013, 10:03 AM

thanks a mill guys, helped greatly

Turning a Vertical Table into a Horizontal one

LinkBack

Thread Tools

Rate This Thread

Display

Turning a Vertical Table into a Horizontal one

Re: Turning a Vertical Table into a Horizontal one

Re: Turning a Vertical Table into a Horizontal one

Re: Turning a Vertical Table into a Horizontal one

Re: Turning a Vertical Table into a Horizontal one

Re: Turning a Vertical Table into a Horizontal one

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions