🔹 1. Row Field kya hota hai?

Row Field wo field hoti hai jiske basis par data ko vertical direction mein arrange kiya jata hai.

Example:

Agar sales data mein ye fields hain:

Agar City ko Rows area mein drag karenge:

👉 Yahan City = Row Field hai.

🔹 2. Column Field kya hota hai?

Column Field wo field hoti hai jiske basis par data ko horizontal direction mein arrange kiya jata hai.

Agar Product ko Columns area mein drag karein:

👉 Yahan City = Row Field aur Product = Column Field hai.

🔹 3. Rows aur Columns mein Field kaise Arrange Karein?

Step 1:

Apne data ke andar kisi bhi cell par click karein.

Step 2:

Insert → PivotTable par click karein.

Step 3:

PivotTable Fields panel open hoga.

Ismein generally 4 areas hote hain:

• Filters
• Columns
• Rows
• Values

Step 4:

Required field ko mouse se drag karke Rows ya Columns area mein drop karein.

Example:

Rows → City
Columns → Product
Values → Sales

Isse Excel city aur product ke according sales ka summary table bana dega.

🔄 4. Row aur Column Field ko Change Karna

Pivot Table ki सबसे अच्छी बात यह है कि आप fields को आसानी से rearrange कर सकते हैं।

पहले:

Rows → City
Columns → Product
Values → Sales

बाद में:

Rows → Product
Columns → City
Values → Sales

Isse report ka structure automatically change ho jayega.

📌 5. Multiple Fields Rows mein

Ek se zyada fields ko Rows area mein bhi arrange kiya ja sakta hai.

Example:

Rows:
    City
    Product

Values:
    Sales

Result kuch is tarah ho sakta hai:

👉 Isse City ke andar Product-wise analysis kiya ja sakta hai.

📊 6. Multiple Fields Columns mein

Columns area mein bhi multiple fields rakhe ja sakte hain.

Example:

Rows → City

Columns:
    Product
    Month

Values → Sales

Isse city ke according Product + Month wise comparison kiya ja sakta hai.

🎯 Practical Example – Student Report

Suppose student data mein:

• Student Name
• Course
• Gender
• Marks

Aap bana sakte hain:

Rows → Course
Columns → Gender
Values → Count of Student Name

Result:

Isse pata chalega ki har course mein kitne students hain aur unka category-wise distribution kya hai.

⭐ Rows vs Columns

💡 Easy Trick

Rows = Kis ke according list/group karna hai?

Columns = Kis ke saath comparison karna hai?

Values = Kya calculate karna hai?

Example:

Rows     → City
Columns  → Product
Values   → Sales

👉 Meaning: Har city mein different products ki total sales compare karna.

⭐ Exam Points

• Rows field data ko vertical direction mein arrange karta hai.
• Columns field data ko horizontal direction mein arrange karta hai.
• Multiple fields ko Rows aur Columns mein add kiya ja sakta hai.
• Fields ko drag-and-drop karke easily rearrange kiya ja sakta hai.
• Rows + Columns + Values milkar two-dimensional analysis create kar sakte hain.
• Pivot Table mein field arrangement ko badalne se report ka structure automatically change ho jata hai.

📝 Short Definition

“Pivot Table mein Rows aur Columns mein fields arrange karna ek process hai jisme data fields ko vertical aur horizontal categories mein organize karke comparison aur analysis ke liye summary report banayi jati hai.”