Dear Expert,
How I can combine the name in Ericsson_GNodeB column ( D column ) since each one name in D column has one or two and more cells in Ericsson_NRCellCU column ( C column) and later easy for me to create pivotable, slicer to create dashboard.
For example
Ericsson_NRCellCU Ericsson_GNodeB
ND0003134F1A BD00031
ND0003134F1B BD00031
ND0003134F1C BD00031
Should be
BD00031 ND0003134F1A
ND0003134F1B
ND0003134F1C
Last edited by OMMM; 01-18-2024 at 12:19 PM.
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The pattern that I noticed from your exemplo is that when Sector is "A" you want to join the columns, I did that in the formula bellow.
Formula:
Please Login or Register to view this content.
Many thanks for your effortsOriginally Posted by DJunqueira
The pattern that I noticed from your exemplo is that when Sector is "A" you want to join the columns, I did that in the formula bellow.
Formula:Please Login or Register to view this content.
in D column has one and more cells/sectors from column C Ericsson_NRCellCU column ( C column) see sheet1 (using pivot table ) in attached file don't use SECTOR column.
Same what you done only use column C & column D. ( the sectors in column C and the site name in column D). under each site name there are one or more sectors.
Ericsson_GNodeB Ericsson_NRCellCU
BB01071 NB0107134F1A
NB0107134F1B
BD00012 ND0001234F1A
ND0001234F1B
ND0001234F1C
BD00031 ND0003134F1A
ND0003134F1B
ND0003134F1C
BD00061 ND0006126F1A
ND0006126F1B
ND0006126F1C
ND0006134F1A
ND0006134F1B
ND0006134F1C
In Post #4 you have the same results as in Post #1, but the headers are switched.
So its unclear what you really want.
One guess: Please try in E2 and copy down:If this is not what you want, please provide an example workbook with the expected results manually added.Formula:Please Login or Register to view this content.
Last edited by HansDouwe; 01-13-2024 at 09:12 AM.
In Post #4 you have the same results as in Post #1, but the headers are switched.
So its unclear what you really want.
One guess: Please try in E2 and copy down:If this is not what you want, please provide an example workbook with the expected results manually added.Formula:Please Login or Register to view this content.
Great many thanks, it is ok now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks