Đã Đóng

Quick Excel question

1) I created an Excel template to export list of payees and their contact info. However, it is exporting the payees as duplicates since it's based on payment. Is there a way to create aa pivot table wherein I could just have the unique list of payees and their contact info (should appear only once)? If so how do I do this? I can send you fake data after recording.

2) Is it possible to turn a PIVOT Table into a CSV with no issues?

$20 per hour

Kĩ năng: Excel, Xử lí dữ liệu, Nhập liệu

Về khách hàng:
( 2 nhận xét ) San Francisco, United States

ID dự án: #33782228

60 freelancer chào giá trung bình$19 cho công việc này

(663 Nhận xét)
8.4
(461 Nhận xét)
8.3
(488 Nhận xét)
7.8
(179 Nhận xét)
6.9
(304 Nhận xét)
7.0
AccountantArman

"Sir, Q#1, Possible Q#2, Also possible I am Excel Advance Level Expert having Experience of over 10 Years. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountan Thêm

$20 USD trong 1 ngày
(176 Nhận xét)
6.5
(114 Nhận xét)
6.4
(71 Nhận xét)
6.4
(62 Nhận xét)
6.3
(124 Nhận xét)
6.1
(75 Nhận xét)
5.7
IgeS

Hi there, There are multiple ways to get the unique value in a dataset, and this depends on the output purpose. I know four methods of doing so (including pivot table). Please send me the dummy data to find out what m Thêm

$20 USD trong 1 ngày
(45 Nhận xét)
5.4
(60 Nhận xét)
5.8
ARTICLEYOUWANT

Quick Excel question Hi, I have seen your project details and completely understand the requirements. Kindly, award me this project so that we can discuss it briefly and start working.

$20 USD trong 1 ngày
(40 Nhận xét)
5.6
PERPETUAL0

Hello there i can help you also for the pivot regards ILYASS

$20 USD trong 1 ngày
(140 Nhận xét)
5.8
muradeltaher

Greetings! My Name Is Murad and I’d like to be considered for your position. I Would Love To Have The Opportunity To Discuss Your Project Further. I Provide certain services : 1. MS Office 2. Web Research 3. Data Thêm

$20 USD trong 7 ngày
(97 Nhận xét)
5.3
(70 Nhận xét)
5.2
AAGGMM

Hello sir I am Ahmed, a GOOGLE certified data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming languag Thêm

$20 USD trong 1 ngày
(40 Nhận xét)
4.9
rameshraja86

Hi There, I can make unique list of payees and pivot table to CSV conversion by VBA. Just a single button click will do all. Contact me to discuss further Thanks

$16 USD trong 1 ngày
(32 Nhận xét)
4.9
(45 Nhận xét)
4.6