Results 1 to 4 of 4

copy values from columns to rows while skipping empty columns...

Threaded View

EricCy copy values from columns to... 01-08-2016, 11:42 AM
Glenn Kennedy Re: copy values from columns... 01-08-2016, 11:59 AM
EricCy Re: copy values from columns... 01-10-2016, 06:02 AM
Glenn Kennedy Re: copy values from columns... 01-10-2016, 06:20 AM
  1. #1
    Registered User
    Join Date
    01-08-2016
    Location
    Cyprus
    MS-Off Ver
    MS Office 2010
    Posts
    2

    copy values from columns to rows while skipping empty columns...

    forum_sample.xlsxtable.png

    Hello! I have a problem in excel that I do not know how to solve.

    I have a sheet "data" with values in columns like in the image. In between the columns there are gaps or other data that I do not want to draw from.

    I have another sheet "calculation" in which I draw from the "data" sheet and do some calculations, calculate some indicators.
    The way I do this, is as if I am transposing the data.

    For example, in the "calculation" sheet, each row will take values from one specific column and do the calculations.

    My problem is the following:

    Because I have many columns in the "data" sheet and many "rows" in the "calculation" sheet, what I want to do is prepare one row and fill-down the formulas and calculations.

    However, when I do this I need to skip the empty columns in the "data" sheet. So if a row takes from column A, then I want the next row to take from column B and and ignore the copy in between. I tried preparing 2 to 3 rows of data like this and fill them down but it doesn't work like this. I have formulas like in the 2nd picture and I want to be able to fill down the sheet.

    RESULT.png

    I hope someone knows a quick work-around on this. Can I do this without using VBAs? I am not experienced in VBA.

    Thank you,

    Eric
    Last edited by EricCy; 01-10-2016 at 06:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-11-2015, 07:47 AM
  2. Transposing columns to rows (while skipping rows)
    By mctighe in forum Excel General
    Replies: 0
    Last Post: 02-09-2015, 03:19 PM
  3. Delete Empty Rows and empty columns from the word table
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 10:51 AM
  4. Transposing rows to columns while skipping a cell
    By jocelyn.gillespie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2014, 08:12 PM
  5. Need help with a macro to copy rows into two columns, ignoring empty cells.
    By ukeleleperson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2014, 04:51 AM
  6. Replies: 2
    Last Post: 11-09-2010, 10:27 AM
  7. [SOLVED] Skipping Columns/Rows
    By Lilbit in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1