Collecting data in columns but need to present it in rows

**perobaja** · 09-09-2020, 03:20 PM

Hi everyone. I am collecting data in columns but need to present it in rows. I have created formula and it working well. I need to exted it on columns I,J,K,L (might be more) and it's to complicated ( formula is to long). Could you help me to find another way to do the task?

**Bernie Deitrick** · 09-09-2020, 04:19 PM

In E3, array-enter (enter using Ctrl-Shift-Enter)

=IFERROR(INDEX($2:$2,SMALL(IF($M3:$ZZ3>0,COLUMN($M3:$ZZ3)),COLUMN(B2)/2)),"")

In F3, array-enter

=IFERROR(INDEX(3:3,SMALL(IF($M3:$ZZ3>0,COLUMN($M3:$ZZ3)),COLUMN(B2)/2)),"")

Copy E3:F3 down to match your list, and then copy E:F to G:J

**perobaja** · 09-09-2020, 05:12 PM

Thank you Bernie Deitrick. It is working great and is much too simple. Like a magic. Best regards!

Collecting data in columns but need to present it in rows

LinkBack

Thread Tools

Rate This Thread

Display

Collecting data in columns but need to present it in rows

Re: Collecting data in columns but need to present it in rows

Re: Collecting data in columns but need to present it in rows

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Collecting data from from multiple columns for a drop down list

[SOLVED] Macro for data present in multiple rows and columns following multiple conditions

[SOLVED] Count and Present Titles from different columns of different rows

collecting data from numerous sheets and collecting into one

[SOLVED] Auto Hiding rows based on range/data present or not present.

[SOLVED] Collecting & Grouping of Data into columns...

Make a macro run on rows/columns only if data is present?

Bookmarks

Bookmarks

Posting Permissions