Results 1 to 18 of 18

Transpose from sheet to another according to a value and the number of columns

Threaded View

  1. 07-21-2023, 12:03 PM #1
    Sybille
    Sybille is offline
    Forum Contributor
    Join Date
    10-09-2018
    Location
    Quebec, Canada
    MS-Off Ver
    Office 365
    Posts
    127

    Transpose from sheet to another according to a value and the number of columns

    Hello Forum,

    I need to copy/transpose data from sheet2 to sheet1 according to a value (item reference) and the number of columns (years) in which said item has an amount.

    You will understand better by viewing the attached file.

    Thank you all in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to transpose rows into columns and paste to specific columns in another sheet
    By LDLDLD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2019, 11:08 AM
  2. [SOLVED] Copy x number of rows to blank row then transpose to columns
    By Spyderwoman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2017, 02:14 PM
  3. Transpose data into two columns based on two related columns through sheet
    By dylanvv in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-03-2015, 03:42 PM
  4. [SOLVED] Automatically transpose the data in sheet 1 rows into columns in sheet 2.
    By Azalea11 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-16-2014, 11:07 AM
  5. [SOLVED] Need to reorganize - transpose columns to rows per article number
    By toblju in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2012, 09:36 PM
  6. Transpose variable number of columns into inserted rows
    By Benvolio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 01:07 AM
  7. [SOLVED] Transpose a variable number of columns to Rows
    By CiskoWalt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2012, 10:57 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1