Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 12-05-2013, 12:46 PM
mlttkw mlttkw is offline Windows 7 64bit Office 2010 64bit
Join Date: Dec 2013
Posts: 2
mlttkw is on a distinguished road
Default transpose values based on mulitple criteria

here is my dilemma. I have a dynamic data source that will have the same distinct Names in column a and b and c and the same of occurrences in each column. Across row 1 the values are also static.
the data within will change

in my output I need to match the distinct values from the input to the output and transpose the values accordingly to the output file

I am attaching my example for better depiction...I am playing around with a combination of Match, Index and Transpose and can't quite get the outcome.

Attached Files
File Type: xlsx Book3.xlsx (11.9 KB, 2 views)
Reply With Quote
Old 12-06-2013, 02:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,086
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice

In C20 enter
and pull down and across
Attached Files
File Type: xlsx Book3(1).xlsx (12.0 KB, 0 views)
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
Transpose cells and skip? ItsjustB Excel 1 01-09-2013 08:53 AM
Conditionally Email People Based on Values in Fields dawsonh2002 Mail Merge 2 12-12-2012 12:11 PM
change values based on cell ubns Excel 1 05-21-2012 06:28 PM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM

All times are GMT -7. The time now is 01:51 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft