Results 1 to 8 of 8

Rearrange data (column to row) and delete unneeded rows

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2010
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Rearrange data (column to row) and delete unneeded rows

    Hi all,

    Pretty sure I should be able to do this already with previous help I have had here but for some reason I am just not getting it...

    Every week I get a spreadsheet with data in the format attached (I've put in four blocks but it could be any number usually thousands). I need to copy the yellow cells in column A and put them in the blank cells next to the blue row in that block, then delete all the rows that aren't blue.

    If anyone could assist, it would be awesome.

    Cheers

    Matt
    Attached Files Attached Files
    Last edited by WaveOfMutilation2; 07-15-2010 at 05:31 AM.

Thread Information

Users Browsing this Thread

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

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