Terminé

Transforming dataset into a different layout - Formula or Array Formula only

Hi,

Please take a look at the attached document.

This shows an example of my 'dataset', and the layout of how I would like it to be transformed...

I would like to accomplish the "End Result" with the use of a formula only - and NO helper columns. - Array formulas are also fine.

** I don't want to use macros **

** I don't want to use pivot tables **

** I don't want to use filters **

I just want a formula or array formula to transform the dataset, into the End Result as shown in the example.

I have colour coded the data to make it easier for you to understand what's happening.

Please take a look and let me know if you are capable of helping me.

Thank you very much.

Compétences : Saisie de Données, Traitement de Données, Excel, Statistiques, Visual Basic

en voir plus : excel formula capture data time day, short different layout design myspace layouts, pimp hi5 different layout, iphone app different layout, different layout pdf vtiger, cre loaded want different layout homepage pages, rolling return formula monthly data, magento category different layout, formula concatenate data, opencart information page different layout, formula table data, typo3 startpage different layout, magento different layout products, different type of tree in data structure, different type of trees in data structure, different types of algorithm in data structure, different types of arrays in data structure, different types of sorting in data structure

Concernant l'employeur :
( 5 commentaires ) IPSWICH, United Kingdom

Nº du projet : #17973733

Décerné à:

scorpionobaid01

Hi I m here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(18 Commentaires)
4.0

18 freelance font une offre moyenne de $103 pour ce travail

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(300 Commentaires)
7.7
bouslimi1979

Hi, it's a very tricky task since you want just formulas... I propose the following : if you are okay, you an award the project and create the milestone. I ll not accept the project before getting it resolved. If I can Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(263 Commentaires)
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your formula. Please send me a message so that we can discuss more.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(282 Commentaires)
7.2
hdlan

Hello, I have a solution to allow transforming dataset into a different layout using formulas only. I can submit a file immediately. Best regards, Duong

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(24 Commentaires)
6.2
sorinacho88

Hello, I have created the formulas already! It was a challenge but I have done it :) No macros, no pivot, no array,no filters. Only plain formulas. Please open a chat with me. Kind regards, Sorin

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(44 Commentaires)
4.9
dataexplorer

"Hi, I would love to help you in your Current Project and it would be with confidence and satisfying results. I'm look forward to hearing from you about the project. Best Regards"

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)
3.4
dangphap

Hello, Yes, it is possible but with some constrains. Your data must be put in some restrict styles and places in order for formulas to work because Excel formulas work base on cell positions. If you want to change t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
2.8
emirhodzic3

Dear, I'm mechanical engineer from Bosnia and Hercegovina with good experience in computer sciene I can finish this job very fast and quality. Best regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.6
sharmaravikantsh

I just saw ur example can u explain more about this.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
maicareyles

Hi! Good day! With regards to your project, i was trying to attached my sample hat I put formula but I can't, anyhow I am interested in working for this project and I assure you that you will not regret choosing me Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
moudud5050

Dear Sir, I write in light of your promotion searching for an information passage aide. As an extremely competent information passage right hand, I would bring an inventive, self-composed, and enthusiastic aura to t Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
maggi1987

I can help you un Excel More details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
alembaptista

Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I am very fast typing and good in redaction or transcription. I have a lot experience with Excel, SPSS Modeler, customer Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
rdb1987

i just did this excel only with formulas like: index, look, count....

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
nicy555

hi there, i used to create a template almost like your requirement for my previous company uaing google spreadsheet and using formulas only. no macros at all. i think this job can be done by me.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
mahesh159753

I can help you with anything with Excel. To prove it, I'm bidding the lowest. you can trust me with any Excel related. I'm rated 4.2/5 in ExcelChat(onine excel tutoring platform)

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
stewartjlogan1

Yes - it is possible by using formula - However some sets of data will return blank Example: Ref 4 Match1 Ref 4 Ref 4 Thats the only way without using some automated manipulation

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0